* 11-year Reintervention Analysis supplement 2.sps.
* Written by PSKL on 2/4/03.

Get file = 'D:\Longitudinal Data\Descriptive Data 1991 to 2001.sav'
 /keep patidn quadrant tooth claimidn doplacn maintrt filled time reptreat reint yearplac.

select if (reint=1).

compute timew= trunc(time/7).

compute timelm= trunc(time/28).

Recode maintrt reptreat
 (1401 thru 1411 = 1)
 (1421 = 2)
 (1426,5836 = 3)
 (1501 thru 1531,5841,6301 thru 6351 = 4)
 (1701 thru 1782, 5111,5112,6501 thru 6523 = 5)
 (2101 thru 2205, 5201 thru 5214 = 6)
 (2733 thru 2863 = 7)
 (1601,6401,1801 thru 1832,6301,9999  = 8)
 into trtgrp reintgrp.

Variable Labels reintgrp 'Type of Reintervention'.
Value Labels reintgrp
1 'Amalgam'
2 'Resin Composite'
3 'Glass Ionomer'
4 'Root filling plus non direct'
5 'Crowns/Inlays'
6 'Extractions'
7 'Dentures'
8 'Other'.

* Restrict to glass ionomers placed between 1994 and 1996 inclusive.

select if (range(yearplac,1994,1996) and trtgrp=3).

CROSSTABS
  /TABLES=timelm BY reintgrp
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT.

Crosstabs

**Notes**
Output Created		02-APR-2003 18:04:32
Comments
Input	Filter	<none>
	Weight	<none>
	Split File	<none>
	N of Rows in Working Data File	8579
Missing Value Handling	Definition of Missing	User-defined missing values are treated as missing.
Missing Value Handling	Cases Used	Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax		CROSSTABS /TABLES=timelm BY reintgrp /FORMAT= AVALUE TABLES /CELLS= COUNT.
Resources	Dimensions Requested	2
	Cells Available	116508
	Elapsed Time	0:00:15.39

**Case Processing Summary**
	Cases
	Valid		Missing		Total
	N	Percent	N	Percent	N	Percent
TIMELM * Type of Reintervention	8579	100.0%	0	.0%	8579	100.0%

**TIMELM * Type of Reintervention Crosstabulation**
Count
		Type of Reintervention								Total
		Amalgam	Resin Composite	Glass Ionomer	Root filling plus non direct	Crowns/Inlays	Extractions	Dentures	Other	Total
TIMELM	.00	39	17	69	9	38	35	3	3	213
	1.00	44	23	94	5	35	21	3	1	226
	2.00	43	20	88	5	32	34	5	2	229
	3.00	41	19	78	6	18	16	5	2	185
	4.00	45	27	83	3	18	24	1	2	203
	5.00	47	32	79	4	32	23	11	4	232
	6.00	83	62	219	11	20	29	1	3	428
	7.00	38	35	137	7	14	19	7	1	258
	8.00	45	24	96	1	18	19	2		205
	9.00	38	29	75	3	12	24	2	4	187
	10.00	33	31	73	2	11	17	11	3	181
	11.00	27	26	58	3	16	18	2	1	151
	12.00	30	23	74	2	13	22	3	2	169
	13.00	54	30	100	4	15	15	3	3	224
	14.00	38	34	62	2	17	24	4		181
	15.00	43	32	39	3	12	13	3	1	146
	16.00	33	27	53	1	8	11	4	2	139
	17.00	32	26	54	3	9	17	2		143
	18.00	27	36	61	2	8	18	4	3	159
	19.00	27	33	58	3	10	26	6		163
	20.00	34	35	53	2	8	18	2	4	156
	21.00	21	27	52	1	10	9	2	2	124
	22.00	21	26	38	4	6	11	5	2	113
	23.00	22	32	30	1	9	10	1	3	108
	24.00	25	30	34		6	17	4	2	118
	25.00	21	30	44		5	9	1		110
	26.00	30	27	28	1	6	7	1		100
	27.00	26	31	39	2	11	8	1	1	119
	28.00	27	31	32	4	6	13	4	1	118
	29.00	23	14	31	1	5	10	2	3	89
	30.00	22	23	34	1	9	9	3		101
	31.00	15	21	25	2	8	10	1	2	84
	32.00	22	35	52	2	2	7			120
	33.00	23	23	25	3	14	5	3	2	98
	34.00	20	26	30	2	3	10	5		96
	35.00	29	27	25	1	5	9	2		98
	36.00	15	25	30	1	6	19	1	1	98
	37.00	16	14	52	1	3	9	1	1	97
	38.00	16	24	20		7	9	1		77
	39.00	10	24	20		3	12	3	1	73
	40.00	16	23	22	1	4	4	4	1	75
	41.00	22	31	26	1	3	11	3		97
	42.00	12	16	20	2	6	15	2		73
	43.00	19	27	33		4	5	3	1	92
	44.00	14	15	28	2	6	12	5		82
	45.00	13	19	27	4	10	6	3	1	83
	46.00	10	15	24		2	7	3		61
	47.00	21	17	24	1	4	7	2		76
	48.00	15	22	15	1	5	6	4	1	69
	49.00	14	17	16	1	4	12	5		69
	50.00	9	19	17	1	3	5	3		57
	51.00	15	29	17	2	4	8	6		81
	52.00	9	21	14		2	4			50
	53.00	16	9	22	3		8	4		62
	54.00	14	14	16	1	4	2	7	1	59
	55.00	12	15	11	1	5	19		1	64
	56.00	13	15	10	1	5	6	2	1	53
	57.00	4	8	29		6	5	1		53
	58.00	9	18	16	1		2	1		47
	59.00	18	16	16	1	3	5	3		62
	60.00	12	11	17	1	6	8	2	1	58
	61.00	19	10	13		2	12			56
	62.00	8	36	17		4	3		1	69
	63.00	16	23	14	1	3	8	1		66
64.00	24	19	11		3	8	4	1	70
65.00	9	12	10	1	3	6	3		44
66.00	12	17	9	3	3	7	3		54
67.00	8	9	12			2			31
68.00	8	16	20	1	2	3	2		52
69.00	6	10	16	1	3	3			39
70.00	9	12	11			4	2		38
71.00	6	8	10	1	3	1	1	2	32
72.00	8	8	3			1			20
73.00	6	12	5			5	1		29
74.00	4	11	7	1	3	4	2		32
75.00	2	17	4		2	2			27
76.00	7	15	5		3	3	2		35
77.00	3	10	4		1	4	2	2	26
78.00	4	3	11		4	3	3		28
79.00	8	12	5			1			26
80.00	2	10	6		2	5	3		28
81.00	7	7	3			3	1		21
82.00	6	9	1	1		4			21
83.00	2	6	3		1	7	1		20
84.00	7	4	4		3	2			20
85.00	1	5	4		2	3	1		16
86.00	2	6	8		2	4	1	1	24
87.00	2	6	1		2	5		1	17
88.00	3	2	3			1			9
89.00	4	3	3			2			12
90.00	2	3		2		2			9
91.00	2	1	1	1	1	2	1		9
92.00	2	4	2						8
93.00	3	1	2	2	1	1	2		12
94.00	1	2	2		1		1		7
95.00		2	1	1		1			5
96.00	1	1	3		1				6
97.00	1	6	1						8
98.00	1	1				1			3
100.00		1	4						5
101.00		1							1
102.00			1		1				2
Total		1748	1829	3004	149	630	916	225	78	8579